package com.readdata;

import java.io.File;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;

import com.po.TabAcceptancecommission;
import com.po.TabAttendance;
import com.po.TabBacnendperformacedata;
import com.po.TabCompletedhomeimprovementorder;
import com.po.TabDepositschedule;
import com.po.TabEmbeddedpipestatistics;
import com.po.TabHomeimprovementsalesstatistics;
import com.po.TabInstallitemdeductpercentage;
import com.po.TabPerformancerewardandpunishment;
import com.po.TabResponsibilitydocuments;
import com.po.TabSalesdetail;
import com.po.TabSuccessfuldeliveryofaonetime;
import com.po.TabThesecondinstallationcommission;
import com.po.TabThesecondinstallationgrants;

public class ReadExcelFile
{

	/**
	 * @fileName 读取文件文件名
	 */
	// 验收提成表(已测)
	public static List<TabAcceptancecommission> readTabAcData(String fileName)
	{
		List<TabAcceptancecommission> tabaclist = new ArrayList<TabAcceptancecommission>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabAcceptancecommission po = new TabAcceptancecommission();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAcdatadate("--");
				}
				else
				{
					po.setAcdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAccode("--");
				}
				else
				{
					po.setAccode(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAcacceptancedate("--");
				}
				else
				{
					po.setAcacceptancedate(sheet.getCell(2, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAccontractno("--");
				}
				else
				{
					po.setAccontractno(sheet.getCell(3, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals("--"))
				{
					po.setAcinspectionpersonnel("--");
				}
				else
				{
					po.setAcinspectionpersonnel(sheet.getCell(4, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAcinstallaccessories("--");
				}
				else
				{
					po.setAcinstallaccessories(sheet.getCell(5, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(6, i).getContents().replaceAll(" ", "")
						.equals(""))
				{
					po.setAcacceptancecommission(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAcacceptancecommission(Float.valueOf(sheet.getCell(6,
							i).getContents().replaceAll(" ", "")));
				}
				if (sheet.getCell(7, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAcremarks("--");
				}
				else
				{
					po.setAcremarks(sheet.getCell(7, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				tabaclist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tabaclist;

	}

	// 考勤表(已测)
	public static List<TabAttendance> readTabAData(String fileName)
	{
		List<TabAttendance> tabalist = new ArrayList<TabAttendance>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabAttendance po = new TabAttendance();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAdatadate("--");
				}
				else
				{
					po.setAdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAdep("--");
				}
				else
				{
					po.setAdep(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAname1("--");
				}
				else
				{
					po.setAname1(sheet.getCell(2, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAbasicwage("--");
				}
				else
				{
					po.setAbasicwage(sheet.getCell(3, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAremarks("--");
				}
				else
				{
					po.setAremarks(sheet.getCell(4, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAofficesituation("--");
				}
				else
				{
					po.setAofficesituation(sheet.getCell(5, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAattendancerecords("--");
				}
				else
				{
					po.setAattendancerecords(sheet.getCell(6, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(7, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAwhethertopositive("--");
				}
				else
				{
					po.setAwhethertopositive(sheet.getCell(7, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(8, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAlate(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAlate(Float.valueOf(sheet.getCell(8, i).getContents()
							.trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(9, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setAleave(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAleave(Float.valueOf(sheet.getCell(9, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(10, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAsickleave(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAsickleave(Float.valueOf(sheet.getCell(10, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(11, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAabsenteeism(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAabsenteeism(Float.valueOf(sheet.getCell(11, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(12, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAovertime(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAovertime(Float.valueOf(sheet.getCell(12, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(13, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAamountshoulbededucted(Float.valueOf("0.000"));
				}
				else
				{
					po.setAamountshoulbededucted(Float.valueOf(sheet.getCell(
							13, i).getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(14, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAovertimepay(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAovertimepay(Float.valueOf(sheet.getCell(14, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(15, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAname2("--");
				}
				else
				{
					po.setAname2(sheet.getCell(15, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(16, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAoverallscharge("--");
				}
				else
				{
					po.setAoverallscharge(sheet.getCell(16, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(17, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAshouldbewithheld(Float.valueOf("--"));
				}
				else
				{
					po.setAshouldbewithheld(Float.valueOf(sheet.getCell(17, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(18, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAloan(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAloan(Float.valueOf(sheet.getCell(18, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(19, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAsocialsecuritydeductions(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAsocialsecuritydeductions(Float.valueOf(sheet
							.getCell(19, i).getContents().trim().replaceAll(
									" ", "")));
				}
				if (sheet.getCell(20, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setAcompanytosocialsecurity(Float.valueOf("0.0000"));
				}
				else
				{
					po.setAcompanytosocialsecurity(Float.valueOf(sheet.getCell(
							20, i).getContents().trim().replaceAll(" ", "")));
				}

				tabalist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tabalist;

	}

	// 后端绩效数据(已测表)
	public static List<TabBacnendperformacedata> readTabbepData(String fileName)
	{
		List<TabBacnendperformacedata> tabbeplist = new ArrayList<TabBacnendperformacedata>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabBacnendperformacedata po = new TabBacnendperformacedata();

				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setBepdatadate("--");
				}
				else
				{
					po.setBepdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setBepddepname("--");
				}
				else
				{
					po.setBepddepname(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").endsWith(""))
				{
					po.setBepddepdescription("--");
				}
				else
				{
					po.setBepddepdescription(sheet.getCell(2, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setBepddata(Float.valueOf("0.0000"));
				}
				else
				{
					po.setBepddata(Float.valueOf(sheet.getCell(3, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				tabbeplist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tabbeplist;

	}

	// 家装完工单统计(已测)
	public static List<TabCompletedhomeimprovementorder> readTabChioData(
			String fileName)
	{
		List<TabCompletedhomeimprovementorder> tablist = new ArrayList<TabCompletedhomeimprovementorder>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabCompletedhomeimprovementorder po = new TabCompletedhomeimprovementorder();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiodatadate("--");
				}
				else
				{
					po.setChiodatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChioyear("--");
				}
				else
				{
					po.setChioyear(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiomonth("--");
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiomonth("--");
				}
				else
				{
					po.setChiomonth(sheet.getCell(2, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChioday("--");
				}
				else
				{
					po.setChioday(sheet.getCell(3, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChioinfocode("--");
				}
				else
				{
					po.setChioinfocode(sheet.getCell(4, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiocustomeraddress("--");
				}
				else
				{
					po.setChiocustomeraddress(sheet.getCell(5, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setHiodesigncontractcode("--");
				}
				else
				{
					po.setHiodesigncontractcode(sheet.getCell(6, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(7, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiohousingarea(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChiohousingarea(Float.valueOf(sheet.getCell(7, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(8, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po
							.setChiodesignofthecontractamount(Float
									.valueOf("0.0000"));
				}
				else
				{
					po.setChiodesignofthecontractamount(Float.valueOf(sheet
							.getCell(8, i).getContents().trim().replaceAll(" ",
									"")));
				}
				if (sheet.getCell(9, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setChiodesignperformancestaff("--");
				}
				else
				{
					po.setChiodesignperformancestaff(sheet.getCell(9, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(10, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioconstructioncontractcode("--");
				}
				else
				{
					po.setChioconstructioncontractcode(sheet.getCell(10, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(11, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChiosignigamount(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChiosignigamount(Float.valueOf(sheet.getCell(11, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(12, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioincomethismonth(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChioincomethismonth(Float.valueOf(sheet
							.getCell(12, i).getContents().trim().replaceAll(
									" ", "")));
				}
				if (sheet.getCell(13, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioconstructionofsettlementamount(Float
							.valueOf("0.0000"));
				}
				else
				{
					po.setChioconstructionofsettlementamount(Float
							.valueOf(sheet.getCell(13, i).getContents().trim()
									.replaceAll(" ", "")));
				}
				if (sheet.getCell(14, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioclearingtheamount(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChioclearingtheamount(Float.valueOf(sheet.getCell(14,
							i).getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(15, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioproductitem(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChioproductitem(Float.valueOf(sheet.getCell(15, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(16, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio1kitchen(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio1kitchen(Float.valueOf(sheet.getCell(16, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(17, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio1bathroom(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio1bathroom(Float.valueOf(sheet.getCell(17, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(18, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio1interiordoors(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio1interiordoors(Float.valueOf(sheet.getCell(18, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(19, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio1customfurniture(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio1customfurniture(Float.valueOf(sheet.getCell(19,
							i).getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(20, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio1total(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio1total(Float.valueOf(sheet.getCell(20, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(21, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio2customfurniture(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio2customfurniture(Float.valueOf(sheet.getCell(21,
							i).getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(22, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio2floor(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio2floor(Float.valueOf(sheet.getCell(22, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(23, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio2sofacloth(Float.valueOf("0.00000"));
				}
				else
				{
					po.setChio2sofacloth(Float.valueOf(sheet.getCell(23, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(24, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio2lighting(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio2lighting(Float.valueOf(sheet.getCell(24, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(25, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChio2total(Float.valueOf("0.0000"));
				}
				else
				{
					po.setChio2total(Float.valueOf(sheet.getCell(25, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(26, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChiodecorationdesigner("--");
				}
				else
				{
					po.setChiodecorationdesigner(sheet.getCell(26, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(27, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioaccountmanager("--");
				}
				else
				{
					po.setChioaccountmanager(sheet.getCell(27, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(28, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChiopromotionofoperationalstaff("--");
				}
				else
				{
					po.setChiopromotionofoperationalstaff(sheet.getCell(28, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(29, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChiostoresales("--");
				}
				else
				{
					po.setChiostoresales(sheet.getCell(29, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(30, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChiosalesshopping("--");
				}
				else
				{
					po.setChiosalesshopping(sheet.getCell(30, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(31, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioclientmanager("--");
				}
				else
				{
					po.setChioclientmanager(sheet.getCell(31, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(32, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setChioremarks("--");
				}
				else
				{
					po.setChioremarks(sheet.getCell(32, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 定金明细表(已测)
	public static List<TabDepositschedule> readTabDsData(String fileName)
	{
		List<TabDepositschedule> tablist = new ArrayList<TabDepositschedule>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabDepositschedule po = new TabDepositschedule();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsdatadate("--");
				}
				else
				{
					po.setDsdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsinfcode("--");
				}
				else
				{
					po.setDsinfcode(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsyear("--");
				}
				else
				{
					po.setDsyear(sheet.getCell(2, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsmonth("--");
				}
				else
				{
					po.setDsmonth(sheet.getCell(3, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsday("--");
				}
				else
				{
					po.setDsday(sheet.getCell(4, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsnumber(Float.valueOf("0.0000"));
				}
				else
				{
					po.setDsnumber(Float.valueOf(sheet.getCell(5, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsproduct("--");
				}
				else
				{
					po.setDsproduct(sheet.getCell(6, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(7, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsproject("--");
				}
				else
				{
					po.setDsproject(sheet.getCell(7, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(8, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsstyle("--");
				}
				else
				{
					po.setDsstyle(sheet.getCell(8, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(9, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setDsmarketrecode("--");
				}
				else
				{
					po.setDsmarketrecode(sheet.getCell(9, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(10, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDssales("--");
				}
				else
				{
					po.setDssales(sheet.getCell(10, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(11, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDssalesshopping("--");
				}
				else
				{
					po.setDssalesshopping(sheet.getCell(11, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(12, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDscustomername("--");
				}
				else
				{
					po.setDscustomername(sheet.getCell(12, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(13, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDscustomeraddress("--");
				}
				else
				{
					po.setDscustomeraddress(sheet.getCell(13, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(14, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDscustomertel("--");
				}
				else
				{
					po.setDscustomertel(sheet.getCell(14, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(15, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsdayadvancesofpayment("--");
				}
				else
				{
					po.setDsdayadvancesofpayment(sheet.getCell(15, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(16, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsnotesnoadvancesofpayment("--");
				}
				else
				{
					po.setDsnotesnoadvancesofpayment(sheet.getCell(16, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(17, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsamoutadvancesofpayment(Float.valueOf("0.0000"));
				}
				else
				{
					po.setDsamoutadvancesofpayment(Float.valueOf(sheet.getCell(
							17, i).getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(18, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDspaymentstatus("--");
				}
				else
				{
					po.setDspaymentstatus(sheet.getCell(18, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(19, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDspaymentmethods("--");
				}
				else
				{
					po.setDspaymentmethods(sheet.getCell(19, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(20, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDs2("--");
				}
				else
				{
					po.setDs2(sheet.getCell(20, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(21, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsorderstatus("--");
				}
				else
				{
					po.setDsorderstatus(sheet.getCell(21, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(22, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDscontractcode("--");
				}
				po.setDscontractcode(sheet.getCell(22, i).getContents().trim()
						.replaceAll(" ", ""));

				if (sheet.getCell(23, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsamount(Float.valueOf("0.0000"));
				}
				else
				{
					po.setDsamount(Float.valueOf(sheet.getCell(23, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(24, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDssignchargebackdate("--");
				}
				else
				{
					po.setDssignchargebackdate(sheet.getCell(24, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(25, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsprogressofchargeback("--");
				}
				else
				{
					po.setDsprogressofchargeback(sheet.getCell(25, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(26, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDstransferbmp("--");
				}
				if (sheet.getCell(26, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDstransferbmp("--");
				}
				else
				{
					po.setDstransferbmp(sheet.getCell(26, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(27, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsbeijingcode("--");
				}
				else
				{
					po.setDsbeijingcode(sheet.getCell(27, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(28, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsdailyreconciliations("--");
				}
				else
				{
					po.setDsdailyreconciliations(sheet.getCell(28, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(29, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDs3("--");
				}
				else
				{
					po.setDs3(sheet.getCell(29, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(30, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsactivites("--");
				}
				if (sheet.getCell(30, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDsactivites("--");
				}
				else
				{
					po.setDsactivites(sheet.getCell(30, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(31, i).getContents().trim().replaceAll(" ",
						"").equals(""))
				{
					po.setDs4("--");
				}
				else
				{
					po.setDs4(sheet.getCell(31, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(32, i).getContents().trim().replaceAll(" ",
						"").equals("--"))
				{
					po.setDsremarks("--");
				}
				else
				{
					po.setDsremarks(sheet.getCell(32, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 预埋烟管统计(已测)
	public static List<TabEmbeddedpipestatistics> readTabEsData(String fileName)
	{
		List<TabEmbeddedpipestatistics> tablist = new ArrayList<TabEmbeddedpipestatistics>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabEmbeddedpipestatistics po = new TabEmbeddedpipestatistics();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEsdatadate("--");
				}
				else
				{
					po.setEsdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEscontractno("--");
				}
				else
				{
					po.setEscontractno(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEsinstallationmaster("--");
				}
				else
				{
					po.setEsinstallationmaster(sheet.getCell(2, i)
							.getContents().trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEsinstall("--");
				}
				else
				{
					po.setEsinstall(sheet.getCell(3, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEsdeductapercentage(Float.valueOf("0.0000"));
				}
				else
				{
					po.setEsdeductapercentage(Float.valueOf(sheet.getCell(4, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setEsremarks("--");
				}
				else
				{
					po.setEsremarks(sheet.getCell(5, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 家装销售明细表(已测)
	public static List<TabHomeimprovementsalesstatistics> readTabHissData(
			String fileName)
	{
		List<TabHomeimprovementsalesstatistics> tablist = new ArrayList<TabHomeimprovementsalesstatistics>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabHomeimprovementsalesstatistics po = new TabHomeimprovementsalesstatistics();
				po.setHissdatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHissyear(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHissmonth(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHissday(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHissinfocode(sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHisscustomeraddress(sheet.getCell(5, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHissdesigncontractcode(sheet.getCell(6, i).getContents()
						.trim().replaceAll(" ", ""));

				po.setHisshousingarea(Float.valueOf(sheet.getCell(7, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setHissdesignofthecontractamount(Float
						.valueOf(sheet.getCell(8, i).getContents().trim()
								.replaceAll(" ", "")));
				po.setHissdesignperformancestaff(sheet.getCell(9, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setHissswhethertheproperty(sheet.getCell(10, i)
						.getContents().trim().replaceAll(" ", ""));

				po.setHissconstructioncontractcode(sheet.getCell(11, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setHissconstructioncontracamount(Float.valueOf(sheet
						.getCell(12, i).getContents().trim()
						.replaceAll(" ", "")));
				po.setHissamountofmoneyback(Float.valueOf(sheet.getCell(13, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHissmoneybackthismonth(Float.valueOf(sheet.getCell(14, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHissconstructionofstaff(sheet.getCell(15, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setHissordermonth(sheet.getCell(16, i).getContents().trim()
						.replaceAll(" ", ""));

				po.setHiss1kitchen(Float.valueOf(sheet.getCell(17, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setHiss1bathroom(Float.valueOf(sheet.getCell(18, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHiss1interiordoors(Float.valueOf(sheet.getCell(19, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHiss1customfurniture(Float.valueOf(sheet.getCell(20, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHiss1total(Float.valueOf(sheet.getCell(21, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHiss2customfurniture(Float.valueOf(sheet.getCell(22, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setHiss2floor(Float.valueOf(sheet.getCell(23, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setHiss2sofacloth(Float.valueOf(sheet.getCell(24, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHiss2lighting(Float.valueOf(sheet.getCell(25, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setHiss2total(Float.valueOf(sheet.getCell(26, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHissproducttotal(Float.valueOf(sheet.getCell(27, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setHissdecorationdesigner(sheet.getCell(28, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHissaccountmanager(sheet.getCell(29, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHisspromotionofoperationalstaff(sheet.getCell(30, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setHissstoresales(sheet.getCell(31, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setHisssalesshopping(sheet.getCell(32, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHisscustomersource(sheet.getCell(33, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHissreceivedthedeposit(sheet.getCell(34, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setHissremarks(sheet.getCell(35, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 安装正单提成(有疑问数据源)
	public static List<TabInstallitemdeductpercentage> readTabIidpData(
			String fileName)
	{
		List<TabInstallitemdeductpercentage> tablist = new ArrayList<TabInstallitemdeductpercentage>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabInstallitemdeductpercentage po = new TabInstallitemdeductpercentage();
				po.setIidpdatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setIidpitemdate(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setIidpcontractno(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setIidpteam(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setIidpemployee(sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setIidpinstalltheratiocooperation(Float
						.valueOf(sheet.getCell(5, i).getContents().trim()
								.replaceAll(" ", "")));
				po.setIidpaccountnumberoforders(sheet.getCell(6, i)
						.getContents().trim().replaceAll(" ", ""));

				po.setIidpnumberofcontracts(Integer.valueOf(sheet.getCell(7, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setIidpscoring(Float.valueOf(sheet.getCell(8, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setIidpinstalltioncommission(Float.valueOf(sheet.getCell(9,
						i).getContents().trim().replaceAll(" ", "")));
				po.setIidprestructuringcharges(sheet.getCell(10, i)
						.getContents().trim().replaceAll(" ", ""));

				po.setIidptotalroyaltyexpenses(Float.valueOf(sheet.getCell(11,
						i).getContents().trim().replaceAll(" ", "")));
				po.setIidpremarks(sheet.getCell(12, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 绩效奖罚(录入)
	public static List<TabPerformancerewardandpunishment> readTabPrapData(
			String fileName)
	{
		List<TabPerformancerewardandpunishment> tablist = new ArrayList<TabPerformancerewardandpunishment>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabPerformancerewardandpunishment po = new TabPerformancerewardandpunishment();
				po.setPrapdatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setPrapemployeecode(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setPrapname(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setPrapremark(Float.valueOf(sheet.getCell(3, i)
						.getContents().trim().replaceAll(" ", "")));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 责任单(已测)
	public static List<TabResponsibilitydocuments> readTabRfsData(
			String fileName)
	{
		List<TabResponsibilitydocuments> tablist = new ArrayList<TabResponsibilitydocuments>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabResponsibilitydocuments po = new TabResponsibilitydocuments();
				po.setRfsdatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfsyear(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfsmonth(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfsday(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfschargeclass(sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfscontractno(sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfsrelateritem(sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", ""));

				po.setRfsproducts(sheet.getCell(7, i).getContents().trim()
						.replaceAll(" ", ""));

				po.setRfsrelatedpersonnel(sheet.getCell(8, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setRfsamount(Float.valueOf(sheet.getCell(9, i).getContents()
						.trim().replaceAll(" ", "")));

				po.setRfsdiscount(Float.valueOf(sheet.getCell(10, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setRfsactualamount(Float.valueOf(sheet.getCell(11, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setRfsabstract(sheet.getCell(12, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setRfsremarks(sheet.getCell(13, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 销售明细表(已测)
	public static List<TabSalesdetail> readTabSdData(String fileName)
	{
		List<TabSalesdetail> tablist = new ArrayList<TabSalesdetail>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabSalesdetail po = new TabSalesdetail();
				po.setSddatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdmonth(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdobject(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSditemno(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdclass(sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdcontract(sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdsalesamountshouldbe(Float.valueOf(sheet.getCell(6, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setSdactualsales(Float.valueOf(sheet.getCell(7, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setSddiscount(Float.valueOf(sheet.getCell(8, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setSdwhetherthedepositnotes(sheet.getCell(9, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setSdmatchingrate(Float.valueOf(sheet.getCell(10, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setSddesigners(sheet.getCell(11, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdsales(sheet.getCell(12, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdsalesshopping(sheet.getCell(13, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdhomeimprovementcompany(sheet.getCell(14, i)
						.getContents().trim().replaceAll(" ", ""));
				po.setSdifnecessary(sheet.getCell(15, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdsource(sheet.getCell(16, i).getContents().trim()
						.replaceAll(" ", ""));

				po.setSdchannelstodatermine(sheet.getCell(17, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setSddiscountnotes(sheet.getCell(18, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdremarks(sheet.getCell(19, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 一次性成功交付(已测)
	public static List<TabSuccessfuldeliveryofaonetime> readTabSdoData(
			String fileName)
	{
		List<TabSuccessfuldeliveryofaonetime> tablist = new ArrayList<TabSuccessfuldeliveryofaonetime>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabSuccessfuldeliveryofaonetime po = new TabSuccessfuldeliveryofaonetime();
				po.setSdodatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdocontractno(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdoyear(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdomonth(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdoday(sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setSdoamount(Float.valueOf(sheet.getCell(5, i).getContents()
						.trim().replaceAll(" ", "")));
				po.setSdodesigners(sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 二次安装提成(有疑问数据源)
	public static List<TabThesecondinstallationcommission> readTabTsicData(
			String fileName)
	{
		List<TabThesecondinstallationcommission> tablist = new ArrayList<TabThesecondinstallationcommission>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabThesecondinstallationcommission po = new TabThesecondinstallationcommission();
				po.setTsicdatadate(sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setTsicitemdate(sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setTsiccontractno(sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setTsicclass(sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", ""));
				po.setTsicnumber(Integer.valueOf(sheet.getCell(4, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setTsicaftermarkethandlers(sheet.getCell(5, i).getContents()
						.trim().replaceAll(" ", ""));
				po.setTsicscoring(Float.valueOf(sheet.getCell(6, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setTsicaftersalesamount(Float.valueOf(sheet.getCell(7, i)
						.getContents().trim().replaceAll(" ", "")));

				po.setTsictransporationcosts(Float.valueOf(sheet.getCell(8, i)
						.getContents().trim().replaceAll(" ", "")));
				po.setTsicremarks(sheet.getCell(9, i).getContents().trim()
						.replaceAll(" ", ""));
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	// 二次安装补助(有疑问数据源)
	public static List<TabThesecondinstallationgrants> readTabTsigData(
			String fileName)
	{
		List<TabThesecondinstallationgrants> tablist = new ArrayList<TabThesecondinstallationgrants>();

		try
		{
			Workbook workbook = Workbook.getWorkbook(new File(fileName));
			Sheet sheet = workbook.getSheet(0);
			int rows = sheet.getRows();
			for (int i = 1; i < rows; i++)
			{
				TabThesecondinstallationgrants po = new TabThesecondinstallationgrants();
				if (sheet.getCell(0, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigdatadate("--");
				}
				else
				{
					po.setTsigdatadate(sheet.getCell(0, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(1, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigdate("--");
				}
				else
				{
					po.setTsigdate(sheet.getCell(1, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(2, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigemployee("--");
				}
				else
				{
					po.setTsigemployee(sheet.getCell(2, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(3, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigcontractno("--");
				}
				else
				{
					po.setTsigcontractno(sheet.getCell(3, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(4, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigsubject("--");
				}
				else
				{
					po.setTsigsubject(sheet.getCell(4, i).getContents().trim()
							.replaceAll(" ", ""));
				}
				if (sheet.getCell(5, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigresponsible("--");
				}
				else
				{
					po.setTsigresponsible(sheet.getCell(5, i).getContents()
							.trim().replaceAll(" ", ""));
				}
				if (sheet.getCell(6, i).getContents().trim()
						.replaceAll(" ", "").equals(""))
				{
					po.setTsigfees(Float.valueOf("0.0000"));
				}
				else
				{
					po.setTsigfees(Float.valueOf(sheet.getCell(6, i)
							.getContents().trim().replaceAll(" ", "")));
				}
				tablist.add(po);
			}

		}
		catch (BiffException ex)
		{
			ex.printStackTrace();
		}
		catch (IOException ex)
		{
			ex.printStackTrace();
		}
		return tablist;

	}

	public static void main(String[] args)
	{
		ArrayList<TabThesecondinstallationcommission> list1 = (ArrayList<TabThesecondinstallationcommission>) ReadExcelFile
				.readTabTsicData("c:/一次性成功交付.xls");
		for (TabThesecondinstallationcommission i : list1)
		{
			System.out.println(i);
		}
	}

}
